clear
clear matrix
clear mata
set matsize 2000
capture log close
local path "D:\BJP\WageShocks\ReplicationFiles"
log using `path'\LogFiles\ACS_Empirical-Analysis.log, replace

graph set window fontface "Times New Roman"

************************************************************
***** Corroborate Effects over Time in OEWS - Figure 3 *****
************************************************************

use `path'\FormattedData\Complete_ACS_Data
reg lnch_occ_employed4 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store r_all_2009
gen r_b=_b[MW_Ch_2Yrs_Ago_1]
gen r_se=_se[MW_Ch_2Yrs_Ago_1]

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh_1 MW_Ch_This_Yr_X_RoutineSh_1 MW_Ch_Last_Yr_X_RoutineSh_1 MW_Ch_2Yrs_Ago_X_RoutineSh_1 MW_Ch_Next_Yr_X_RoutineSh_2 MW_Ch_This_Yr_X_RoutineSh_2 MW_Ch_Last_Yr_X_RoutineSh_2 MW_Ch_2Yrs_Ago_X_RoutineSh_2  MW_Ch_Next_Yr_X_RoutineSh_3 MW_Ch_This_Yr_X_RoutineSh_3 MW_Ch_Last_Yr_X_RoutineSh_3 MW_Ch_2Yrs_Ago_X_RoutineSh_3 MW_Ch_Next_Yr_X_RoutineSh_4 MW_Ch_This_Yr_X_RoutineSh_4 MW_Ch_Last_Yr_X_RoutineSh_4 MW_Ch_2Yrs_Ago_X_RoutineSh_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store rcs_all_2009
gen rcs_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh_1]
gen rcs_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh_1]

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh2_1 MW_Ch_This_Yr_X_RoutineSh2_1 MW_Ch_Last_Yr_X_RoutineSh2_1 MW_Ch_2Yrs_Ago_X_RoutineSh2_1 MW_Ch_Next_Yr_X_RoutineSh2_2 MW_Ch_This_Yr_X_RoutineSh2_2 MW_Ch_Last_Yr_X_RoutineSh2_2 MW_Ch_2Yrs_Ago_X_RoutineSh2_2  MW_Ch_Next_Yr_X_RoutineSh2_3 MW_Ch_This_Yr_X_RoutineSh2_3 MW_Ch_Last_Yr_X_RoutineSh2_3 MW_Ch_2Yrs_Ago_X_RoutineSh2_3 MW_Ch_Next_Yr_X_RoutineSh2_4 MW_Ch_This_Yr_X_RoutineSh2_4 MW_Ch_Last_Yr_X_RoutineSh2_4 MW_Ch_2Yrs_Ago_X_RoutineSh2_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh2_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store rms_all_2009
gen rms_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh2_1]
gen rms_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh2_1]

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2  MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store rs_all_2009
gen rs_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh3_1]
gen rs_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh3_1]

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2  MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store int_all_2009
gen int_b=_b[MW_Ch_2Yrs_Ago_X_IntSh_1]
gen int_se=_se[MW_Ch_2Yrs_Ago_X_IntSh_1]

forvalues k=2010/2014{

reg lnch_occ_employed4 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store r_all_`k'
replace r_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==(`k'-2008)
replace r_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==(`k'-2008)

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh_1 MW_Ch_This_Yr_X_RoutineSh_1 MW_Ch_Last_Yr_X_RoutineSh_1 MW_Ch_2Yrs_Ago_X_RoutineSh_1 MW_Ch_Next_Yr_X_RoutineSh_2 MW_Ch_This_Yr_X_RoutineSh_2 MW_Ch_Last_Yr_X_RoutineSh_2 MW_Ch_2Yrs_Ago_X_RoutineSh_2  MW_Ch_Next_Yr_X_RoutineSh_3 MW_Ch_This_Yr_X_RoutineSh_3 MW_Ch_Last_Yr_X_RoutineSh_3 MW_Ch_2Yrs_Ago_X_RoutineSh_3 MW_Ch_Next_Yr_X_RoutineSh_4 MW_Ch_This_Yr_X_RoutineSh_4 MW_Ch_Last_Yr_X_RoutineSh_4 MW_Ch_2Yrs_Ago_X_RoutineSh_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store rcs_all_`k'
replace rcs_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh_1] if [_n]==(`k'-2008)
replace rcs_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh_1] if [_n]==(`k'-2008)

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh2_1 MW_Ch_This_Yr_X_RoutineSh2_1 MW_Ch_Last_Yr_X_RoutineSh2_1 MW_Ch_2Yrs_Ago_X_RoutineSh2_1 MW_Ch_Next_Yr_X_RoutineSh2_2 MW_Ch_This_Yr_X_RoutineSh2_2 MW_Ch_Last_Yr_X_RoutineSh2_2 MW_Ch_2Yrs_Ago_X_RoutineSh2_2  MW_Ch_Next_Yr_X_RoutineSh2_3 MW_Ch_This_Yr_X_RoutineSh2_3 MW_Ch_Last_Yr_X_RoutineSh2_3 MW_Ch_2Yrs_Ago_X_RoutineSh2_3 MW_Ch_Next_Yr_X_RoutineSh2_4 MW_Ch_This_Yr_X_RoutineSh2_4 MW_Ch_Last_Yr_X_RoutineSh2_4 MW_Ch_2Yrs_Ago_X_RoutineSh2_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh2_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store rms_all_`k'
replace rms_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh2_1] if [_n]==(`k'-2008)
replace rms_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh2_1] if [_n]==(`k'-2008)

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2  MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store rs_all_`k'
replace rs_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh3_1] if [_n]==(`k'-2008)
replace rs_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh3_1] if [_n]==(`k'-2008)

reg lnch_occ_employed4 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2  MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store int_all_`k'
replace int_b=_b[MW_Ch_2Yrs_Ago_X_IntSh_1] if [_n]==(`k'-2008)
replace int_se=_se[MW_Ch_2Yrs_Ago_X_IntSh_1] if [_n]==(`k'-2008)
}

gen altyear=[_n]+2008 
gen altyear2=altyear+0.05
gen altyear3=altyear-0.05

gen r_bu=r_b - 1.96*r_se
gen r_bl=r_b + 1.96*r_se
gen rcs_bu=rcs_b - 1.96*rcs_se
gen rcs_bl=rcs_b + 1.96*rcs_se
gen rms_bu=rms_b - 1.96*rms_se
gen rms_bl=rms_b + 1.96*rms_se
gen rs_bu=rs_b - 1.96*rs_se
gen rs_bl=rs_b + 1.96*rs_se
gen int_bu=int_b - 1.96*int_se
gen int_bl=int_b + 1.96*int_se

twoway (connected rcs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(A. Routine Cognitive Share) legend(off)) (rcap rcs_bu rcs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RCS, replace))
twoway (connected rms_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(B. Routine Manual Share) legend(off)) (rcap rms_bu rms_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RMS, replace))
twoway (connected rs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(C. Overall Routine Share) legend(off)) (rcap rs_bu rs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RS, replace))
twoway (connected int_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(D. Interpersonal Share) legend(off)) (rcap int_bu int_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\Int, replace)) 


*********************************************************************************************************
** Table 5: Corroborate OEWS & Perform Subgroup Analysis, Including Over Time (Appendix Figures A3-A5) **
*********************************************************************************************************

reg lnch_occ_employed4 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store r_all
reg lnch_occ_employed4 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2  MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_all
reg lnch_occ_employed4 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2  MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_all
   
local groups2 "low_edu he young old na_poc wa male female"
foreach y of local groups2 {
reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store r2009_`y'
gen r_`y'_b=_b[MW_Ch_2Yrs_Ago_1]
gen r_`y'_se=_se[MW_Ch_2Yrs_Ago_1]

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2  MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_`y'_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store rs2009_`y'
gen rs_`y'_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh3_1]
gen rs_`y'_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh3_1]

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2  MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_`y'_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2009, cluster(statename)
estimates store int2009_`y'
gen int_`y'_b=_b[MW_Ch_2Yrs_Ago_X_IntSh_1]
gen int_`y'_se=_se[MW_Ch_2Yrs_Ago_X_IntSh_1]

forvalues k=2010/2014{
reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store r`k'_`y'
replace r_`y'_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==(`k'-2008)
replace r_`y'_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==(`k'-2008)

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2  MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_`y'_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store rs`k'_`y'
replace rs_`y'_b=_b[MW_Ch_2Yrs_Ago_X_RoutineSh3_1] if [_n]==(`k'-2008)
replace rs_`y'_se=_se[MW_Ch_2Yrs_Ago_X_RoutineSh3_1] if [_n]==(`k'-2008)

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2  MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_`y'_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=`k', cluster(statename)
estimates store int`k'_`y'
replace int_`y'_b=_b[MW_Ch_2Yrs_Ago_X_IntSh_1] if [_n]==(`k'-2008)
replace int_`y'_se=_se[MW_Ch_2Yrs_Ago_X_IntSh_1] if [_n]==(`k'-2008)
}
}

foreach y of local groups2 {
gen r_`y'_bu=r_`y'_b - 1.96*r_`y'_se
gen r_`y'_bl=r_`y'_b + 1.96*r_`y'_se
gen rs_`y'_bu=rs_`y'_b - 1.96*rs_`y'_se
gen rs_`y'_bl=rs_`y'_b + 1.96*rs_`y'_se
gen int_`y'_bu=int_`y'_b - 1.96*int_`y'_se
gen int_`y'_bl=int_`y'_b + 1.96*int_`y'_se
}

twoway (connected rs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(A. Young vs. Old) legend(order(1 "Full Sample" 2 "Younger" 3 "Older" ) col(3)  size(vsmall))) (connected rs_young_b altyear2 if [_n]<7, color(maroon)) (connected rs_old_b altyear3 if [_n]<7, color(green)) (rcap rs_bu rs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RS-Age, replace))  (rcap rs_young_bu rs_young_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap rs_old_bu rs_old_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected rs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(B. Less Educated vs. More Educated) legend(order(1 "Full Sample" 2 "Less-Educated" 3 "More-Educated" ) col(3) size(vsmall))) (connected rs_low_edu_b altyear2 if [_n]<7, color(maroon)) (connected rs_he_b altyear3 if [_n]<7, color(green)) (rcap rs_bu rs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RS-Ed, replace))  (rcap rs_low_edu_bu rs_low_edu_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap rs_he_bu rs_he_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected rs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(C. Non-Asian People of Color vs. White & Asian Americans) legend(order(1 "Full Sample" 2 "People of Color" 3 "White/Asian" ) col(3) size(vsmall))) (connected rs_na_poc_b altyear2 if [_n]<7, color(maroon)) (connected rs_wa_b altyear3 if [_n]<7, color(green)) (rcap rs_bu rs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RS-Race, replace))  (rcap rs_na_poc_bu rs_na_poc_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap rs_wa_bu rs_wa_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected rs_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(D. Male vs. Female) legend(order(1 "Full Sample" 2 "Female" 3 "Male" ) col(3) size(vsmall))) (connected rs_female_b altyear2 if [_n]<7, color(maroon)) (connected rs_male_b altyear3 if [_n]<7, color(green)) (rcap rs_bu rs_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\RS-Sex, replace))  (rcap rs_female_bu rs_female_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap rs_male_bu rs_male_bl altyear3 if [_n]<7, color(green)  lp(dash)) 

twoway (connected int_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(A. Young vs. Old) legend(order(1 "Full Sample" 2 "Younger" 3 "Older" ) col(3)  size(vsmall))) (connected int_young_b altyear2 if [_n]<7, color(maroon)) (connected int_old_b altyear3 if [_n]<7, color(green)) (rcap int_bu int_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\Int-Age, replace))  (rcap int_young_bu int_young_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap int_old_bu int_old_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected int_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(B. Less Educated vs. More Educated) legend(order(1 "Full Sample" 2 "Less-Educated" 3 "More-Educated" ) col(3) size(vsmall))) (connected int_low_edu_b altyear2 if [_n]<7, color(maroon)) (connected int_he_b altyear3 if [_n]<7, color(green)) (rcap int_bu int_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\Int-Ed, replace))  (rcap int_low_edu_bu int_low_edu_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap int_he_bu int_he_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected int_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(C. Non-Asian People of Color vs. White & Asian Americans) legend(order(1 "Full Sample" 2 "People of Color" 3 "White/Asian" ) col(3) size(vsmall))) (connected int_na_poc_b altyear2 if [_n]<7, color(maroon)) (connected int_wa_b altyear3 if [_n]<7, color(green)) (rcap int_bu int_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\Int-Race, replace))  (rcap int_na_poc_bu int_na_poc_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap int_wa_bu int_wa_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected int_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(D. Male vs. Female) legend(order(1 "Full Sample" 2 "Female" 3 "Male" ) col(3) size(vsmall))) (connected int_female_b altyear2 if [_n]<7, color(maroon)) (connected int_male_b altyear3 if [_n]<7, color(green)) (rcap int_bu int_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\Int-Sex, replace))  (rcap int_female_bu int_female_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap int_male_bu int_male_bl altyear3 if [_n]<7, color(green)  lp(dash)) 

twoway (connected r_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(A. Young vs. Old) legend(order(1 "Full Sample" 2 "Younger" 3 "Older" ) col(3)  size(vsmall))) (connected r_young_b altyear2 if [_n]<7, color(maroon)) (connected r_old_b altyear3 if [_n]<7, color(green)) (rcap r_bu r_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\R-Age, replace))  (rcap r_young_bu r_young_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap r_old_bu r_old_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected r_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(B. Less Educated vs. More Educated) legend(order(1 "Full Sample" 2 "Less-Educated" 3 "More-Educated" ) col(3) size(vsmall))) (connected r_low_edu_b altyear2 if [_n]<7, color(maroon)) (connected r_he_b altyear3 if [_n]<7, color(green)) (rcap r_bu r_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\R-Ed, replace))  (rcap r_low_edu_bu r_low_edu_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap r_he_bu r_he_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected r_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(C. Non-Asian People of Color vs. White & Asian Americans) legend(order(1 "Full Sample" 2 "People of Color" 3 "White/Asian" ) col(3) size(vsmall))) (connected r_na_poc_b altyear2 if [_n]<7, color(maroon)) (connected r_wa_b altyear3 if [_n]<7, color(green)) (rcap r_bu r_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\R-Race, replace))  (rcap r_na_poc_bu r_na_poc_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap r_wa_bu r_wa_bl altyear3 if [_n]<7, color(green)  lp(dash)) 
twoway (connected r_b altyear if [_n]<7, color(navy) ytitle(Estimated Elasticity, size(small)) xtitle(Sample Years) xlabel(2009 "2009 - 2018" 2010 "2010 - 2018" 2011 "2011 - 2018" 2012 "2012 - 2018" 2013 "2013 - 2018" 2014 "2014 - 2018", labs(vsmall)) title(D. Male vs. Female) legend(order(1 "Full Sample" 2 "Female" 3 "Male" ) col(3) size(vsmall))) (connected r_female_b altyear2 if [_n]<7, color(maroon)) (connected r_male_b altyear3 if [_n]<7, color(green)) (rcap r_bu r_bl altyear if [_n]<7, color(navy)  lp(dash) saving(`path'\Figures\temp\R-Sex, replace))  (rcap r_female_bu r_female_bl altyear2 if [_n]<7, color(maroon)  lp(dash))  (rcap r_male_bu r_male_bl altyear3 if [_n]<7, color(green)  lp(dash)) 

clear

*********************************************************
** Why Unique Experiences of Non-Asian People of Color **
*********************************************************

********** Clean up and Summarize Racial Resentment Data from Smith, Kreitzer, and Suo (2019) **
use `path'\RawData\RacialResentment
gen cent21=(year>2000)
collapse (mean) resent_score, by(state state_abbrev cent21)
sort state cent21
gen d_resentment= resent_score-resent_score[_n-1] if state==state[_n-1]
gen t_resent_score20= resent_score if cent21==0
egen resent_score20=mode(t_resent_score20), by(state)
keep if cent21==1
** Figure A7: State-Level Changes in Racial Resentment **
scatter resent_score20 d_resentment, mlabel(state_abbrev) ytitle(Average Resentment Score 1988-2000) xtitle(Change in Average Resentment Score Since 2000) title("Figure A7: Changes in Racial Resentment by State Over Time" "1988-2016") note("Note: This figure plots the average racial resentment score by state over the period 1988-2000 (measured" "as the average score in 1988, 1990, 1992, 1994, 2000) against the change in the average resentment score" "since 2000, where the recent average resentment score is based on measurements of racial resentment in" "2004, 2008, 2012, and 2016.  Positive changes reflect an increase in racial resentment. All state-level" "racial resentment values are from Smith, Kreitzer, and Suo (2019).") legend(off) saving("`path'\Figures\FigureA7", replace) || lfit resent_score20 d_resentment
*************************
keep state resent_score resent_score20 d_resentment
rename state statename
save `path'\FormattedData\RacialResentment2, replace
clear

****************************************************************************************
******* Asymetric Response for Non-Asian People of Color - Table 6 and Figure A6********
****************************************************************************************
use `path'\FormattedData\Complete_ACS_Data

drop if share_r==.
rename share_r share_rs
rename share_r_cog share_rcs
rename share_r_man share_rms

local tasks "rs int"
foreach z of local tasks {
forvalues k=1/4{
pctile double t_p1090_`z'_gr`k'=share_`z' [fweight=tot_emp] if year>=2010 & group==`k', nq(10)
gen double t_p50_`z'_gr`k' = t_p1090_`z'_gr`k' if [_n]==5
egen double p50_`z'_gr`k'=mode(t_p50_`z'_gr`k')
gen double t_p70_`z'_gr`k' = t_p1090_`z'_gr`k' if [_n]==7
egen double p70_`z'_gr`k'=mode(t_p70_`z'_gr`k')
gen double t_p90_`z'_gr`k' = t_p1090_`z'_gr`k' if [_n]==9
egen double p90_`z'_gr`k'=mode(t_p90_`z'_gr`k')
}
}

foreach x of numlist 50 70 90 {
foreach z of local tasks {
gen double p`x'_`z'=p`x'_`z'_gr1 if group==1
forvalues k=2/4{
replace p`x'_`z'=p`x'_`z'_gr`k' if group==`k'
}
drop p`x'_`z'_gr*
}
}
drop t_p* 


*****************************
** Difference in Treatment **
*****************************
** Figure A6 **
local tasks "rs int"
local groups2 "na_poc wa"

foreach y of local groups2 {
foreach p of local tasks {
gen `p'_ptile_`y'_b=.
gen `p'_ptile_`y'_se=.

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & share_`p'<=p50_`p', cluster(statename)
estimates store `p'_`y'_L50
replace `p'_ptile_`y'_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==1
replace `p'_ptile_`y'_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==1

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & share_`p'>p50_`p', cluster(statename)
estimates store `p'_`y'_M50
replace `p'_ptile_`y'_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==2
replace `p'_ptile_`y'_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==2

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & share_`p'>=p70_`p', cluster(statename)
estimates store `p'_`y'_M70
replace `p'_ptile_`y'_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==3
replace `p'_ptile_`y'_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==3

reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & share_`p'>=p90_`p', cluster(statename)
estimates store `p'_`y'_M90
replace `p'_ptile_`y'_b=_b[MW_Ch_2Yrs_Ago_1] if [_n]==4
replace `p'_ptile_`y'_se=_se[MW_Ch_2Yrs_Ago_1] if [_n]==4
}
}

foreach y of local groups2 {
foreach p of local tasks {
gen `p'_ptile_`y'_bu=`p'_ptile_`y'_b - 1.96*`p'_ptile_`y'_se
gen `p'_ptile_`y'_bl=`p'_ptile_`y'_b + 1.96*`p'_ptile_`y'_se
}
}
gen newyear=[_n]
gen newyear2=newyear+0.25

twoway (bar rs_ptile_na_poc_b newyear  if [_n]<5, color(navy) ytitle(Estimated Elasticity) xtitle(Occupation Routine Share Intensity) xlabel(1 `""Less than" "50th" "Percentile""' 2 `""More than" "50th" "Percentile""' 3 `""More than" "70th" "Percentile""' 4 `""More than" "90th" "Percentile""', labs(vsmall)) title(A. Routine Share) legend(order(1 "Non-Asian People of Color" 2 "White and Asian Sample")) barwidth(0.25)) (bar rs_ptile_wa_b newyear2  if [_n]<5, color(maroon) barwidth(0.25)) (rcap rs_ptile_na_poc_bu rs_ptile_na_poc_bl newyear if [_n]<5, color(navy)  lp(dash)) (rcap rs_ptile_wa_bu rs_ptile_wa_bl newyear2 if [_n]<5, color(maroon)  lp(dash) saving(`path'\Figures\temp\RS_Intensity-v3, replace))
twoway (bar int_ptile_na_poc_b newyear if [_n]<5, color(navy) ytitle(Estimated Elasticity) xtitle(Occupation Interpersonal Share Intensity) xlabel(1 `""Less than" "50th" "Percentile""' 2 `""More than" "50th" "Percentile""' 3 `""More than" "70th" "Percentile""' 4 `""More than" "90th" "Percentile""', labs(vsmall)) title(B. Interpersonal Share) legend(order(1 "Non-Asian People of Color" 2 "White and Asian Sample")) barwidth(0.25)) (bar int_ptile_wa_b newyear2  if [_n]<5, color(maroon) barwidth(0.25)) (rcap int_ptile_na_poc_bu int_ptile_na_poc_bl newyear if [_n]<5, color(navy)  lp(dash)) (rcap int_ptile_wa_bu int_ptile_wa_bl newyear2 if [_n]<5, color(maroon)  lp(dash) saving(`path'\Figures\temp\Int_Intensity-v3, replace))


** Table 6 - Difference in Treatment **
gen pos_rs=(share_rs>p50_rs)
gen neg_rs=(share_rs<=p50_rs)

local yrs "Next_Yr This_Yr Last_Yr 2Yrs_Ago"
forvalues k=1/4{
foreach y of local yrs {
gen pos_MW_Ch_`y'_X_RS3_`k'=MW_Ch_`y'_X_RoutineSh3_`k'*pos_rs
gen neg_MW_Ch_`y'_X_RS3_`k'=MW_Ch_`y'_X_RoutineSh3_`k'*neg_rs
}
}

reg lnch_occ_employed4 pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_1_* lgr_oe4_2_* lgr_oe4_3_* lgr_oe4_4_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_w] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store all_rs3
reg lnch_occ_emp4_na_poc pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_na_poc_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store na_poc_rs3
reg lnch_occ_emp4_wa pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_wa_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store wa_rs3


*********************************
** Racial Resentment - Table 7 **
*********************************

merge m:1 statename using `path'\FormattedData\RacialResentment2

replace d_resentment=d_resentment*100

forvalues k=1/4{
gen dr_MW_Ch_Next_Yr_`k'=MW_Ch_Next_Yr_`k'*d_resentment
gen dr_MW_Ch_This_Yr_`k'=MW_Ch_This_Yr_`k'*d_resentment
gen dr_MW_Ch_Last_Yr_`k'=MW_Ch_Last_Yr_`k'*d_resentment
gen dr_MW_Ch_2Yrs_Ago_`k'=MW_Ch_2Yrs_Ago_`k'*d_resentment
gen dr_gr`k'=d_resentment*group_dum`k'
}

** Overall Employment by Changes in Resentment **

reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & _merge==3, cluster(statename)
estimates store r_na_poc
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 dr_MW_Ch_Next_Yr_1 dr_MW_Ch_This_Yr_1 dr_MW_Ch_Last_Yr_1 dr_MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 dr_MW_Ch_Next_Yr_2 dr_MW_Ch_This_Yr_2 dr_MW_Ch_Last_Yr_2 dr_MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 dr_MW_Ch_Next_Yr_3 dr_MW_Ch_This_Yr_3 dr_MW_Ch_Last_Yr_3 dr_MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 dr_MW_Ch_Next_Yr_4 dr_MW_Ch_This_Yr_4 dr_MW_Ch_Last_Yr_4 dr_MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* dr_gr* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & _merge==3, cluster(statename)
estimates store r_na_poc_dr

reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & _merge==3, cluster(statename)
estimates store r_wa
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 dr_MW_Ch_Next_Yr_1 dr_MW_Ch_This_Yr_1 dr_MW_Ch_Last_Yr_1 dr_MW_Ch_2Yrs_Ago_1   MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 dr_MW_Ch_Next_Yr_2 dr_MW_Ch_This_Yr_2 dr_MW_Ch_Last_Yr_2 dr_MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 dr_MW_Ch_This_Yr_3 dr_MW_Ch_Last_Yr_3 dr_MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 dr_MW_Ch_Next_Yr_4 dr_MW_Ch_This_Yr_4 dr_MW_Ch_Last_Yr_4 dr_MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* dr_gr* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & _merge==3, cluster(statename)
estimates store r_wa_dr

** Differential Treatment by Changes in Resentment **

reg lnch_occ_emp4_na_poc pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_na_poc_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & d_resentment>2.5, cluster(statename)
estimates store na_poc_rs3_hdr
reg lnch_occ_emp4_wa pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_wa_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & d_resentment>2.5, cluster(statename)
estimates store wa_rs3_hdr

reg lnch_occ_emp4_na_poc pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_na_poc_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & d_resentment<=2.5, cluster(statename)
estimates store na_poc_rs3_ldr
reg lnch_occ_emp4_wa pos_MW_Ch_Next_Yr_X_RS3_* pos_MW_Ch_This_Yr_X_RS3_* pos_MW_Ch_Last_Yr_X_RS3_* pos_MW_Ch_2Yrs_Ago_X_RS3_* neg_MW_Ch_Next_Yr_X_RS3_* neg_MW_Ch_This_Yr_X_RS3_* neg_MW_Ch_Last_Yr_X_RS3_* neg_MW_Ch_2Yrs_Ago_X_RS3_* lgr_oe4_wa_* group_dum* state_yr* i.onetsoccode ind_dum* gr_RoutineSh3_* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & d_resentment<=2.5, cluster(statename)
estimates store wa_rs3_ldr

********************************************************************
** Add additional Leads & Lags of Minimum Wage Change - Table A7 **
********************************************************************

gen MW_Ch_InTwo_Yrs=(ln(f2mw)-ln(fmw))
gen MW_Ch_InThree_Yrs=(ln(f3mw)-ln(f2mw))
gen MW_Ch_3Yrs_Ago=(ln(l3mw)-ln(l4mw))

local tasks "RoutineSh3 IntSh"
forvalues k=1/4{
gen MW_Ch_InTwo_Yrs_`k'=MW_Ch_InTwo_Yrs*group_dum`k'
gen MW_Ch_InThree_Yrs_`k'=MW_Ch_InThree_Yrs*group_dum`k'
gen MW_Ch_3Yrs_Ago_`k'=MW_Ch_3Yrs_Ago*group_dum`k'
foreach y of local tasks {
gen MW_Ch_InTwo_Yrs_X_`y'_`k'=MW_Ch_InTwo_Yrs*group_dum`k'*`y'
gen MW_Ch_InThree_Yrs_X_`y'_`k'=MW_Ch_InThree_Yrs*group_dum`k'*`y'
gen MW_Ch_3Yrs_Ago_X_`y'_`k'=MW_Ch_3Yrs_Ago*group_dum`k'*`y'
}
}

********* Include Additional Leads *******************
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store na_poc_3yrb
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_na_poc_3yrb
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_na_poc_3yrb

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store wa_3yrb
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_wa_3yrb
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_wa_3yrb


********* Include Additional Lags *******************
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store na_poc_3yra
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_na_poc_3yra
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_na_poc_3yra

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store wa_3yra
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_wa_3yra
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_wa_3yra


********* Include Additional Leads & Lags *******************
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store na_poc_3yrba
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_na_poc_3yrba
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_na_poc_3yrba

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store wa_3yrba
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_wa_3yrba
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_wa_3yrba


********* Include Additional Leads & Lags (Limit to Large Occupations) *******************
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store na_poc_3yrba_lo
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store rs_na_poc_3yrba_lo
reg lnch_occ_emp4_na_poc MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store int_na_poc_3yrba_lo

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1 MW_Ch_InThree_Yrs_2 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_3Yrs_Ago_2 MW_Ch_InThree_Yrs_3 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_3Yrs_Ago_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 MW_Ch_3Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store wa_3yrba_lo
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_3Yrs_Ago_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_3Yrs_Ago_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 MW_Ch_3Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store rs_wa_3yrba_lo
reg lnch_occ_emp4_wa MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_3Yrs_Ago_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_3Yrs_Ago_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 MW_Ch_3Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store int_wa_3yrba_lo


************ Change outcome to 3-Year Employment Changes, Include 2 additional Leads **********
** Non-Asian People of Color **
reg lnch_occ_emp3_na_poc MW_Ch_InThree_Yrs_1 MW_Ch_InThree_Yrs_2 MW_Ch_InThree_Yrs_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe3_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp3_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store na_poc_3yr2_3yrb
reg lnch_occ_emp3_na_poc MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe3_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp3_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store rs_na_poc_3yr2_3yrb
reg lnch_occ_emp3_na_poc MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe3_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp3_wna_poc] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store int_na_poc_3yr2_3yrb

** White and Asian Americans **
reg lnch_occ_emp3_wa MW_Ch_InThree_Yrs_1 MW_Ch_InThree_Yrs_2 MW_Ch_InThree_Yrs_3 MW_Ch_InThree_Yrs_4 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_InTwo_Yrs_2 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_InTwo_Yrs_3 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_InTwo_Yrs_4 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe3_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp3_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store wa_3yr2_3yrb
reg lnch_occ_emp3_wa MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InThree_Yrs_X_RoutineSh3_2 MW_Ch_InThree_Yrs_X_RoutineSh3_3 MW_Ch_InThree_Yrs_X_RoutineSh3_4 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_InTwo_Yrs_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_InTwo_Yrs_X_RoutineSh3_4 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe3_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp3_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store rs_wa_3yr2_3yrb
reg lnch_occ_emp3_wa MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InThree_Yrs_X_IntSh_2 MW_Ch_InThree_Yrs_X_IntSh_3 MW_Ch_InThree_Yrs_X_IntSh_4 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_InTwo_Yrs_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_InTwo_Yrs_X_IntSh_4 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe3_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* [pweight=orig_emp3_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2013, cluster(statename)
estimates store int_wa_3yr2_3yrb

*************************************************
** Exclude Employment-based Weights - Table B2 **
*************************************************

** Exclude Employment-based Weights **
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store na_poc_unw
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_na_poc_unw
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_na_poc_unw

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store wa_unw
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store rs_wa_unw
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
estimates store int_wa_unw
   
** Exclude Employment-based Weights & Exclude Large Employment Changes**
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store na_poc_unw2
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store rs_na_poc_unw2
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store int_na_poc_unw2

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store wa_unw2
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store rs_wa_unw2
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & lnch_occ_employed4<1 & lnch_occ_employed4>-1, cluster(statename)
estimates store int_wa_unw2

** Exclude Employment-based Weights & Limit to Large Occupations **
** Non-Asian People of Color **
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store na_poc_unw3
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_na_poc_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store rs_na_poc_unw3
reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_na_poc_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store int_na_poc_unw3

** White and Asian Americans **
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_wa_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store wa_unw3
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4 lgr_oe4_wa_* group_dum* gr_RoutineSh3_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store rs_wa_unw3
reg lnch_occ_emp4_wa MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4 lgr_oe4_wa_* group_dum* gr_IntSh_* state_yr* i.onetsoccode ind_dum* if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & orig_emp4>49, cluster(statename)
estimates store int_wa_unw3
   
   
   
*************
** Results **
*************

** Significance Stars **

** Table 5 **
estimates table r_all r2014_low_edu r2014_he r2014_young r2014_old r2014_na_poc r2014_wa r2014_female r2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Overall)
estimates table rs_all rs2014_low_edu rs2014_he rs2014_young rs2014_old rs2014_na_poc rs2014_wa rs2014_female rs2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Routine)
estimates table int_all int2014_low_edu int2014_he int2014_young int2014_old int2014_na_poc int2014_wa int2014_female int2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Interpersonal)

** Table 6 **
estimates table all_rs3 na_poc_rs3 wa_rs3, b(%7.3f) stats(N r2_a)  keep(pos_MW_Ch_Next_Yr_X_RS3_1 pos_MW_Ch_This_Yr_X_RS3_1 pos_MW_Ch_Last_Yr_X_RS3_1 pos_MW_Ch_2Yrs_Ago_X_RS3_1 neg_MW_Ch_Next_Yr_X_RS3_1 neg_MW_Ch_This_Yr_X_RS3_1 neg_MW_Ch_Last_Yr_X_RS3_1 neg_MW_Ch_2Yrs_Ago_X_RS3_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall Emp Effects in ACS)

** Table 7 **
estimates table r_na_poc r_na_poc_dr r_wa r_wa_dr, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 dr_MW_Ch_Next_Yr_1 dr_MW_Ch_This_Yr_1 dr_MW_Ch_Last_Yr_1 dr_MW_Ch_2Yrs_Ago_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall Emp Effects in ACS)
estimates table na_poc_rs3_hdr na_poc_rs3_ldr wa_rs3_hdr wa_rs3_ldr, b(%7.3f) stats(N r2_a)  keep(pos_MW_Ch_Next_Yr_X_RS3_1 pos_MW_Ch_This_Yr_X_RS3_1 pos_MW_Ch_Last_Yr_X_RS3_1 pos_MW_Ch_2Yrs_Ago_X_RS3_1 neg_MW_Ch_Next_Yr_X_RS3_1 neg_MW_Ch_This_Yr_X_RS3_1 neg_MW_Ch_Last_Yr_X_RS3_1 neg_MW_Ch_2Yrs_Ago_X_RS3_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall Emp Effects in ACS)

** Table A5 **
estimates table r_all r2014_low_edu r2014_he r2014_young r2014_old r2014_na_poc r2014_wa r2014_female r2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Overall)
estimates table rs_all rs2014_low_edu rs2014_he rs2014_young rs2014_old rs2014_na_poc rs2014_wa rs2014_female rs2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Routine)
estimates table int_all int2014_low_edu int2014_he int2014_young int2014_old int2014_na_poc int2014_wa int2014_female int2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4) varwidth(30) star(0.1, 0.05, 0.01) title(Emp Effects by Demographic Groups in ACS: Interpersonal)

** Table A7 **
estimates table r2014_na_poc na_poc_3yrb na_poc_3yra na_poc_3yrba na_poc_3yrba_lo na_poc_3yr2_3yrb r2014_wa wa_3yrb wa_3yra wa_3yrba wa_3yrba_lo wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall Effects Including Additional Leads and Lags)
estimates table rs2014_na_poc rs_na_poc_3yrb rs_na_poc_3yra rs_na_poc_3yrba rs_na_poc_3yrba_lo rs_na_poc_3yr2_3yrb rs2014_wa rs_wa_3yrb rs_wa_3yra rs_wa_3yrba rs_wa_3yrba_lo rs_wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1) varwidth(30) star(0.1, 0.05, 0.01) title(Effects by Routine Share Including Additional Leads and Lags)
estimates table int2014_na_poc int_na_poc_3yrb int_na_poc_3yra int_na_poc_3yrba int_na_poc_3yrba_lo int_na_poc_3yr2_3yrb int2014_wa int_wa_3yrb int_wa_3yra int_wa_3yrba int_wa_3yrba_lo int_wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall by Interpersonal Share Including Additional Leads and Lags)

** Table B2 **
estimates table r2014_na_poc na_poc_unw na_poc_unw2 na_poc_unw3 r2014_wa wa_unw wa_unw2 wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) star(0.1, 0.05, 0.01) title(Overall Employment Effects, Impact of Employment-based Weights)
estimates table rs2014_na_poc rs_na_poc_unw rs_na_poc_unw2 rs_na_poc_unw3 rs2014_wa rs_wa_unw rs_wa_unw2 rs_wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1) varwidth(30) star(0.1, 0.05, 0.01) title(Employment Effects by Routine Share, Impact of Employment-based Weights)
estimates table int2014_na_poc int_na_poc_unw int_na_poc_unw2 int_na_poc_unw3 int2014_wa int_wa_unw int_wa_unw2 int_wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1) varwidth(30) star(0.1, 0.05, 0.01) title(Employment Effects by Interpersonal Share, Impact of Employment-based Weights)

** Standard Errors **

** Table 5 **
estimates table r_all r2014_low_edu r2014_he r2014_young r2014_old r2014_na_poc r2014_wa r2014_female r2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Overall)
estimates table rs_all rs2014_low_edu rs2014_he rs2014_young rs2014_old rs2014_na_poc rs2014_wa rs2014_female rs2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Routine)
estimates table int_all int2014_low_edu int2014_he int2014_young int2014_old int2014_na_poc int2014_wa int2014_female int2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Interpersonal)

** Table 6 **
estimates table all_rs3 na_poc_rs3 wa_rs3, b(%7.3f) stats(N r2_a)  keep(pos_MW_Ch_Next_Yr_X_RS3_1 pos_MW_Ch_This_Yr_X_RS3_1 pos_MW_Ch_Last_Yr_X_RS3_1 pos_MW_Ch_2Yrs_Ago_X_RS3_1 neg_MW_Ch_Next_Yr_X_RS3_1 neg_MW_Ch_This_Yr_X_RS3_1 neg_MW_Ch_Last_Yr_X_RS3_1 neg_MW_Ch_2Yrs_Ago_X_RS3_1) varwidth(30) se title(Overall Emp Effects in ACS)

** Table 7 **
estimates table r_na_poc r_na_poc_dr r_wa r_wa_dr, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 dr_MW_Ch_Next_Yr_1 dr_MW_Ch_This_Yr_1 dr_MW_Ch_Last_Yr_1 dr_MW_Ch_2Yrs_Ago_1) varwidth(30) se title(Overall Emp Effects in ACS)
estimates table na_poc_rs3_hdr na_poc_rs3_ldr wa_rs3_hdr wa_rs3_ldr, b(%7.3f) stats(N r2_a)  keep(pos_MW_Ch_Next_Yr_X_RS3_1 pos_MW_Ch_This_Yr_X_RS3_1 pos_MW_Ch_Last_Yr_X_RS3_1 pos_MW_Ch_2Yrs_Ago_X_RS3_1 neg_MW_Ch_Next_Yr_X_RS3_1 neg_MW_Ch_This_Yr_X_RS3_1 neg_MW_Ch_Last_Yr_X_RS3_1 neg_MW_Ch_2Yrs_Ago_X_RS3_1) varwidth(30) se title(Overall Emp Effects in ACS)

** Table A5 **
estimates table r_all r2014_low_edu r2014_he r2014_young r2014_old r2014_na_poc r2014_wa r2014_female r2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2 MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Overall)
estimates table rs_all rs2014_low_edu rs2014_he rs2014_young rs2014_old rs2014_na_poc rs2014_wa rs2014_female rs2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_2 MW_Ch_This_Yr_X_RoutineSh3_2 MW_Ch_Last_Yr_X_RoutineSh3_2 MW_Ch_2Yrs_Ago_X_RoutineSh3_2 MW_Ch_Next_Yr_X_RoutineSh3_3 MW_Ch_This_Yr_X_RoutineSh3_3 MW_Ch_Last_Yr_X_RoutineSh3_3 MW_Ch_2Yrs_Ago_X_RoutineSh3_3 MW_Ch_Next_Yr_X_RoutineSh3_4 MW_Ch_This_Yr_X_RoutineSh3_4 MW_Ch_Last_Yr_X_RoutineSh3_4 MW_Ch_2Yrs_Ago_X_RoutineSh3_4) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Routine)
estimates table int_all int2014_low_edu int2014_he int2014_young int2014_old int2014_na_poc int2014_wa int2014_female int2014_male, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_2 MW_Ch_This_Yr_X_IntSh_2 MW_Ch_Last_Yr_X_IntSh_2 MW_Ch_2Yrs_Ago_X_IntSh_2 MW_Ch_Next_Yr_X_IntSh_3 MW_Ch_This_Yr_X_IntSh_3 MW_Ch_Last_Yr_X_IntSh_3 MW_Ch_2Yrs_Ago_X_IntSh_3 MW_Ch_Next_Yr_X_IntSh_4 MW_Ch_This_Yr_X_IntSh_4 MW_Ch_Last_Yr_X_IntSh_4 MW_Ch_2Yrs_Ago_X_IntSh_4) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Interpersonal)

** Table A7 **
estimates table r2014_na_poc na_poc_3yrb na_poc_3yra na_poc_3yrba na_poc_3yrba_lo na_poc_3yr2_3yrb r2014_wa wa_3yrb wa_3yra wa_3yrba wa_3yrba_lo wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_1 MW_Ch_InTwo_Yrs_1 MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1 MW_Ch_3Yrs_Ago_1) varwidth(30) se title(Overall Effects Including Additional Leads and Lags)
estimates table rs2014_na_poc rs_na_poc_3yrb rs_na_poc_3yra rs_na_poc_3yrba rs_na_poc_3yrba_lo rs_na_poc_3yr2_3yrb rs2014_wa rs_wa_3yrb rs_wa_3yra rs_wa_3yrba rs_wa_3yrba_lo rs_wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_X_RoutineSh3_1 MW_Ch_InTwo_Yrs_X_RoutineSh3_1 MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1 MW_Ch_3Yrs_Ago_X_RoutineSh3_1) varwidth(30) se title(Effects by Routine Share Including Additional Leads and Lags)
estimates table int2014_na_poc int_na_poc_3yrb int_na_poc_3yra int_na_poc_3yrba int_na_poc_3yrba_lo int_na_poc_3yr2_3yrb int2014_wa int_wa_3yrb int_wa_3yra int_wa_3yrba int_wa_3yrba_lo int_wa_3yr2_3yrb, b(%7.3f) stats(N r2_a)  keep(MW_Ch_InThree_Yrs_X_IntSh_1 MW_Ch_InTwo_Yrs_X_IntSh_1 MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1 MW_Ch_3Yrs_Ago_X_IntSh_1) varwidth(30) se title(Overall by Interpersonal Share Including Additional Leads and Lags)

** Table B2 **
estimates table r2014_na_poc na_poc_unw na_poc_unw2 na_poc_unw3 r2014_wa wa_unw wa_unw2 wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) se title(Overall Employment Effects, Impact of Employment-based Weights)
estimates table rs2014_na_poc rs_na_poc_unw rs_na_poc_unw2 rs_na_poc_unw3 rs2014_wa rs_wa_unw rs_wa_unw2 rs_wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_RoutineSh3_1 MW_Ch_This_Yr_X_RoutineSh3_1 MW_Ch_Last_Yr_X_RoutineSh3_1 MW_Ch_2Yrs_Ago_X_RoutineSh3_1) varwidth(30) se title(Employment Effects by Routine Share, Impact of Employment-based Weights)
estimates table int2014_na_poc int_na_poc_unw int_na_poc_unw2 int_na_poc_unw3 int2014_wa int_wa_unw int_wa_unw2 int_wa_unw3, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_X_IntSh_1 MW_Ch_This_Yr_X_IntSh_1 MW_Ch_Last_Yr_X_IntSh_1 MW_Ch_2Yrs_Ago_X_IntSh_1) varwidth(30) se title(Employment Effects by Interpersonal Share, Impact of Employment-based Weights)

***************************
** Figure 3 **
graph combine "`path'\Figures\temp\RCS" "`path'\Figures\temp\RMS" "`path'\Figures\temp\RS" "`path'\Figures\temp\Int", title("Figure 3: Employment Effects of Minimum Wage Hikes in the ACS") subtitle("Two-Year After Effects by Task Intensity over Time") saving(`path'\Figures\Figure3, replace) note("This figure plots the two-year after effects of minimum wage hikes by task share as the sample period changes."  "Sample years reflect years of four-year changes and standard error bars relect 95% confidence intervals.")
** Appendix Tables A3-A5 **
graph combine "`path'\Figures\temp\R-Age" "`path'\Figures\temp\R-Ed" "`path'\Figures\temp\R-Race" "`path'\Figures\temp\R-Sex" , ycommon title("Figure A2: Overall Employment Effects of Minimum Wage") subtitle("Two-Year After Effect - By Demographic Groups Over Time") saving(`path'\Figures\FigureA3, replace) note("Notes: This figure presents the two-year after effects of the overall employment effect of minimum wage hikes" "on specific demographic groups over time.  Young workers are less than 30.  Less-educated workers have a high" "school diploma or less.  Non-Asian People of Color include all non-White/non-Asian American workers.  The" "sample years are samples years of four-year employment changes and the standard error bars reflect 95% confidence" "intervals.")
graph combine "`path'\Figures\temp\RS-Age" "`path'\Figures\temp\RS-Ed" "`path'\Figures\temp\RS-Race" "`path'\Figures\temp\RS-Sex" , ycommon title("Figure A3: Employment Effects of Minimum Wage by Routine Intensity") subtitle("Two-Year After Effect - By Demographic Groups Over Time") saving(`path'\Figures\FigureA4, replace) note("Notes: This figure presents the two-year after effects of minimum wage hikes on employment as the routine share" "of employment increases.  See the notes of Figure A2 for the definitions of the demographic groups.  Standard" "error bars reflect 95% confidence intervals and sample years reflect years of four-year changes in employment.")
graph combine "`path'\Figures\temp\Int-Age" "`path'\Figures\temp\Int-Ed" "`path'\Figures\temp\Int-Race" "`path'\Figures\temp\Int-Sex" , ycommon title("Figure A4: Employment Effects of Minimum Wage by Interpersonal Intensity") subtitle("Two-Year After Effect - By Demographic Groups Over Time") saving(`path'\Figures\FigureA5, replace) note("Notes: This figure presents the two-year after effects of minimum wage hikes on employment as the interpersonal" "share of employment increases.  See the notes of Figure A2 for the definitions of the demographic groups.  Standard" "error bars reflect 95% confidence intervals and sample years reflect years of four-year changes in employment.")
** Appendix Figure A6  **
grc1leg "`path'\Figures\temp\RS_Intensity-v3" "`path'\Figures\temp\Int_Intensity-v3", ycommon title("Figure A6: Two-Year After Employment Effects of Minimum Wage Hikes") subtitle("For Low-Wage Occupations in the ACS by Task-Intensity") saving(`path'\Figures\FigureA6, replace) note("Notes: These figures plot the two-year after elasticities on the overall employment effects of minimum wage" "hikes as the sample of occupations becomes more routine and more interpersonal. The estimates come" "from empirical analyses of the ACS data 2010-2018 estimated separately by race.  The standard error bars" "reflect 95% confidence intervals.")

**************************
******** EXTRAS **********
**************************

*****************************************
** Table A4 - Occ/state/year Estimates **
** Go into ACS_PrepData&CleanUp.do and **
** change command in line 224 to:      **
** replace indp=9999 , i.e. delete     **
** "if  tot_lw_ind<15000" at the end   **
** of the command line. Then, rerun    **
** the program and re-estimate the     **
** results associated with Table 6 in  **
** this file.
*****************************************

*****************************************
** To estimate regression results for  **
** black workers and other racial      **
** groups in the Non-Asian People of   **
** color sample    **********************
*****************************************
**local groups2 "blk opoc"
**foreach y of local groups2 {
**reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
**estimates store r2014_`y'
**}
**estimates table r2014_blk r2014_opoc, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Overall Impact of MW) 


**************************************
** To compute Segregation ratios by **
** run the following commands.      **
**************************************
**use `path'\FormattedData\Complete_ACS_Data
**keep if group==1
**drop if share_r==.
**collapse (sum) tot_emp tot_emp_na_poc tot_emp_wa, by(onetsoccode description)
**gen sh_na_poc=tot_emp_na_poc/tot_emp
**gsort -sh_na_poc
**keep if tot_emp>500
**keep if sh_na_poc>0.3 | sh_na_poc<0.134
**keep onetsoccode sh_na_poc
**clear

**************************************
** To estimation overall employment **
** effects of MW without the most   **
** segregated occupations run the   **
** following commands.              **
**************************************
**use `path'\FormattedData\Complete_ACS_Data
**gen new_te=tot_emp if share_r~=.
**gen new_te_na_poc=tot_emp_na_poc if share_r~=.
**egen tot_emp_new=sum(new_te), by(onetsoccode description group)
**egen tot_emp_new_napoc=sum(new_te_na_poc), by(onetsoccode description group)
**gen sh_na_poc=tot_emp_new_napoc/tot_emp_new
**gen soi=1
**replace soi=0 if sh_na_poc>0.3 & group==1 & tot_emp_new>500 | sh_na_poc<0.134 & group==1 & tot_emp_new>500
**local groups2 "na_poc wa"
**foreach y of local groups2 {
**reg lnch_occ_emp4_`y' MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_`y'_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_w`y'] if ave2_state_w2mw<6 & oes_info==1 & year>=2014 & soi==1, cluster(statename)
**estimates store alt_r2014_`y'
**}
**estimates table alt_r2014_na_poc alt_r2014_wa, b(%7.3f) stats(N r2_a)  keep(MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1) varwidth(30) se title(Emp Effects by Demographic Groups in ACS: Exclude Most Segregated Occs) 
**clear

**************************************
** Using different weights  to test **
** difference in exposure as a pot- **
** ential explanation for racial    **
** differences.                     **
**************************************
**use `path'\FormattedData\Complete_ACS_Data
**reg lnch_occ_emp4_na_poc MW_Ch_Next_Yr_1 MW_Ch_This_Yr_1 MW_Ch_Last_Yr_1 MW_Ch_2Yrs_Ago_1  MW_Ch_Next_Yr_2 MW_Ch_This_Yr_2 MW_Ch_Last_Yr_2 MW_Ch_2Yrs_Ago_2  MW_Ch_Next_Yr_3 MW_Ch_This_Yr_3 MW_Ch_Last_Yr_3 MW_Ch_2Yrs_Ago_3 MW_Ch_Next_Yr_4 MW_Ch_This_Yr_4 MW_Ch_Last_Yr_4 MW_Ch_2Yrs_Ago_4 lgr_oe4_na_poc_* group_dum* state_dum* year_dum* i.onetsoccode ind_dum* [pweight=orig_emp4_wwa] if ave2_state_w2mw<6 & oes_info==1 & year>=2014, cluster(statename)
**clear
